
/*
*备注：权限按钮操作表
*时间：2014年3月3日 14:16:06
*/

CREATE TABLE Base_Button
(
	Button_ID VARCHAR2(50) NOT NULL PRIMARY KEY,
	Button_Name VARCHAR2(50),
	Button_Title VARCHAR2(50),
	Button_Img VARCHAR2(50),
	Button_Code VARCHAR2(50),
	SortCode INT,
	Button_Type VARCHAR2(50),
	Button_Remak VARCHAR2(200),
	DeleteMark INT DEFAULT(1),
	CreateDate DATE DEFAULT(SYSDATE),
	CreateUserId VARCHAR2(50),
	CreateUserName VARCHAR2(50),
	ModifyDate DATE,
	ModifyUserId VARCHAR2(50),
	ModifyUserName VARCHAR2(50)
);

comment on table Base_Button is '权限按钮操作表';
comment on table Base_Button.Button_ID is '按钮ID';
comment on table Base_Button.Button_Name is '按钮名称';
comment on table Base_Button.Button_Title is '按钮标记';
comment on table Base_Button.Button_Img is '按钮图标';
comment on table Base_Button.Button_Code is 'Button_Code';
comment on table Base_Button.SortCode is '排序码';
comment on table Base_Button.Button_Type is '类型';
comment on table Base_Button.Button_Remak is '描述';
comment on table Base_Button.DeleteMark is '删除标记';
comment on table Base_Button.CreateDate is '创建时间';
comment on table Base_Button.CreateUserId is '创建用户主键';
comment on table Base_Button.CreateUserName is '创建用户';
comment on table Base_Button.ModifyDate is '修改时间';
comment on table Base_Button.ModifyUserId is '修改用户主键';
comment on table Base_Button.ModifyUserName is '修改用户';

